﻿CREATE TABLE [dbo].[Locatii] (
    [IDLocatie]     SMALLINT     IDENTITY (1, 1) NOT NULL,
    [Denumire]      VARCHAR (50) NOT NULL,
    [IDDepartament] INT          NOT NULL,
    CONSTRAINT [PK_Locatii] PRIMARY KEY CLUSTERED ([IDLocatie] ASC),
    CONSTRAINT [FK_Locatii_Departamente] FOREIGN KEY ([IDDepartament]) REFERENCES [dbo].[Departamente] ([IDDepartament])
);

